| HSStudentLeaseHistory_Proxy |
| EntityType | Independent |
| Logical Entity Name | HSStudentLeaseHistory_Proxy |
| Default Table Name | HSStudentLeaseHistory_Proxy |
| Logical Only | NO |
| Owner | dbo |
| Definition | |
| Note |
| HSStudentLeaseHistory_Proxy Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
HSStudentLeaseHistory_ProxyID |
INTEGER | NO | ||
| RecordID | INTEGER | NO | ||
| OldStartDate | DATETIME | YES | ||
| NewStartDate | DATETIME | YES | ||
| OldMoveOutDate | DATETIME | YES | ||
| NewMoveOutDate | DATETIME | YES | ||
| OldEndDate | DATETIME | YES | ||
| NewEndDate | DATETIME | YES | ||
| OldActualEndDate | DATETIME | YES | ||
| NewActualEndDate | DATETIME | YES | ||
| OldAdTermID | INTEGER | YES | ||
| NewAdTermID | INTEGER | YES | ||
| OldHSLeaseStatusID | INTEGER | YES | ||
| NewHSLeaseStatusID | INTEGER | YES | ||
| OldSyStudentID | INTEGER | YES | ||
| NewSyStudentID | INTEGER | YES | ||
| OldHSBuildingRoomsID | INTEGER | YES | ||
| NewHSBuildingRoomsID | INTEGER | YES | ||
| OldHSStudentApplicationID | INTEGER | YES | ||
| NewHSStudentApplicationID | INTEGER | YES | ||
| OldHSMoveOutReasonID | INTEGER | YES | ||
| NewHSMoveOutReasonID | INTEGER | YES | ||
| OldLeaseAmount | MONEY(19, 4) | YES | ||
| NewLeaseAmount | MONEY(19, 4) | YES | ||
| OldFrequency | CHAR(1) | YES | ||
| NewFrequency | CHAR(1) | YES | ||
| OldTerminationFee | MONEY(19, 4) | YES | ||
| NewTerminationFee | MONEY(19, 4) | YES | ||
| OldSaBillCodeID | INTEGER | YES | ||
| NewSaBillCodeID | INTEGER | YES | ||
| UserID | INTEGER | NO | ||
| DateAdded | DATETIME | NO | ||
| OldAdEnrollID | INTEGER | YES | ||
| NewAdEnrollID | INTEGER | YES | ||
| OldLastPrintDate | DATETIME | YES | ||
| NewLastPrintDate | DATETIME | YES | ||
| OldFaStudentAYID | INTEGER | YES | ||
| NewFaStudentAYID | INTEGER | YES | ||
| OldReason | VARCHAR(max) | YES | ||
| NewReason | VARCHAR(max) | YES | ||
| ts | TIMESTAMP/DATE | NO | ||
| OldSaTransCodeID | INTEGER | YES | ||
| NewSaTransCodeID | INTEGER | YES | ||
| OldSaBillTermID | INTEGER | YES | ||
| NewSaBillTermID | INTEGER | YES |
| HSStudentLeaseHistory_Proxy Keys |
| Key Name | Key Type | Keys |
| PK_HSStudentLeaseHistory_ProxyHSStudentLeaseHistory_ProxyID | PrimaryKey | HSStudentLeaseHistory_ProxyID |
| HSStudentLeaseHistory_Proxy Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| HSStudentLeaseHistory_Proxy Check Constraints |
| Check Constraint Name | CheckConstraint |
| HSStudentLeaseHistory_Proxy Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical dbo.HSStudentLeaseHistory_Proxy |
NO | |||
| Physical (Microsoft SQL Server) dbo.HSStudentLeaseHistory_Proxy |
NO |
| HSStudentLeaseHistory_Proxy Where Used - Submodel Usage |
| Model | Submodel Usage |
| Logical | Main Model |
| Physical (Microsoft SQL Server) | Main Model |
| Physical (Microsoft SQL Server) | Housing |
| HSStudentLeaseHistory_Proxy Data Movement Rules |
| Name | Type | Rule Text/Value |